CREATE TABLE [dbo].[tb_SubTiposCaracteristicas]
(
[IdSubtipo] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TipoCaracteristica] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_SubTiposCaracteristicas] ADD CONSTRAINT [PK_tb_subtiposCaracteristicas] PRIMARY KEY NONCLUSTERED  ([IdSubtipo]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_SubTiposCaracteristicas] ADD CONSTRAINT [FK_tb_SubTiposCaracteristicas_tb_TiposCaracteristicas] FOREIGN KEY ([TipoCaracteristica]) REFERENCES [dbo].[tb_TiposCaracteristicas] ([idTipoCaracteristicas])
GO
